Display numbers with scientific notation

  1. Select the cells you want to format.
  2. On the Format menu, click Cells, and then click the Number tab.
  3. In the Category list, click Scientific. In the Decimal places box, enter the number of decimal places you want to display.